import kf_lib_v2_2 as lib
import sqlite3

import weather



class Flightplanner:
    def __init__(self, route):
        
        #help(sqlite3.connect)
        self.aopa = sqlite3.connect("Source Data\\aopa.sqlite")
        
        self.c=self.aopa.cursor()
        #help(self.aopa.cursor)
        
        #help(self.c.execute)
        self.res = self.c.execute("select * from airports")
        
        colnames = [col[0] for col in self.c.description]
        self.airports = dict([(k[1], dict(zip(colnames, k))) for k in self.res])
        
        
        
        self.wx = weather.weather()
        
fp = Flightplanner("KRFD DEN")